Overview

Dataset statistics

Number of variables37
Number of observations109
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.2 KiB
Average record size in memory143.2 B

Variable types

BOOL24
NUM11
DATE1
CAT1

Reproduction

Analysis started2020-08-17 20:11:14.773675
Analysis finished2020-08-17 20:12:13.192950
Duration58.42 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

# Drops has constant value "1" Constant
Offer ID1 has constant value "4915" Constant
Remaining Budget has constant value "0" Constant
Name_First Access Solid B has constant value "1" Constant
Offer Name1_First Access Solid Black Visa Credit Card - Display - Lead Submit - W4 (e-mail) has constant value "1" Constant
Operational Status1_Live has constant value "1" Constant
Payout Type1_1st PAGE SUBMIT has constant value "1" Constant
Opens is highly correlated with DeliveredHigh correlation
Delivered is highly correlated with OpensHigh correlation
Data Provider (group)_Venice is highly correlated with Data Provider (group)_IrvineHigh correlation
Data Provider (group)_Irvine is highly correlated with Data Provider (group)_VeniceHigh correlation
Delivered has unique values Unique
eCPM has 5 (4.6%) zeros Zeros
EPC has 5 (4.6%) zeros Zeros
CLR has 33 (30.3%) zeros Zeros
Revenue has 5 (4.6%) zeros Zeros

Variables

Affiliate ID1
Real number (ℝ≥0)

Distinct count34
Unique (%)31.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean460599.7706422018
Minimum460121
Maximum460828
Zeros0
Zeros (%)0.0%
Memory size872.0 B

Quantile statistics

Minimum460121
5-th percentile460351
Q1460454
median460628
Q3460744
95-th percentile460809
Maximum460828
Range707
Interquartile range (IQR)290

Descriptive statistics

Standard deviation163.4923621
Coefficient of variation (CV)0.0003549553702
Kurtosis-0.5038418059
Mean460599.7706
Median Absolute Deviation (MAD)145
Skewness-0.4711826948
Sum50205375
Variance26729.75246
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
46080987.3%
 
46063976.4%
 
46080465.5%
 
46046765.5%
 
46058754.6%
 
46062854.6%
 
46045154.6%
 
46066154.6%
 
46039854.6%
 
46044343.7%
 
Other values (24)5348.6%
 
ValueCountFrequency (%) 
46012110.9%
 
46021821.8%
 
46029710.9%
 
46035132.8%
 
46037943.7%
 
ValueCountFrequency (%) 
46082843.7%
 
46080987.3%
 
46080465.5%
 
46076743.7%
 
46076610.9%
 

eCPM
Real number (ℝ≥0)

ZEROS

Distinct count96
Unique (%)88.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.150550458715596
Minimum0.0
Maximum21.9
Zeros5
Zeros (%)4.6%
Memory size872.0 B

Quantile statistics

Minimum0
5-th percentile0.236
Q11.62
median3.74
Q35.54
95-th percentile11.006
Maximum21.9
Range21.9
Interquartile range (IQR)3.92

Descriptive statistics

Standard deviation3.496684365
Coefficient of variation (CV)0.8424628009
Kurtosis5.318753487
Mean4.150550459
Median Absolute Deviation (MAD)1.99
Skewness1.769663976
Sum452.41
Variance12.22680155
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
054.6%
 
3.8232.8%
 
1.1732.8%
 
1.1821.8%
 
4.2321.8%
 
1.9821.8%
 
2.2921.8%
 
1.5621.8%
 
6.9510.9%
 
1.6410.9%
 
Other values (86)8678.9%
 
ValueCountFrequency (%) 
054.6%
 
0.2210.9%
 
0.2610.9%
 
0.3410.9%
 
0.410.9%
 
ValueCountFrequency (%) 
21.910.9%
 
12.5810.9%
 
12.0110.9%
 
11.7610.9%
 
11.4110.9%
 

CTR
Real number (ℝ≥0)

Distinct count93
Unique (%)85.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.014433944954128438
Minimum0.001
Maximum0.0534
Zeros0
Zeros (%)0.0%
Memory size872.0 B

Quantile statistics

Minimum0.001
5-th percentile0.00272
Q10.0082
median0.0128
Q30.0185
95-th percentile0.03044
Maximum0.0534
Range0.0524
Interquartile range (IQR)0.0103

Descriptive statistics

Standard deviation0.009292771187
Coefficient of variation (CV)0.6438136779
Kurtosis3.291188583
Mean0.01443394495
Median Absolute Deviation (MAD)0.0052
Skewness1.474736473
Sum1.5733
Variance8.635559633e-05
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.010843.7%
 
0.008932.8%
 
0.023221.8%
 
0.008621.8%
 
0.009721.8%
 
0.013521.8%
 
0.01321.8%
 
0.012221.8%
 
0.006721.8%
 
0.014721.8%
 
Other values (83)8678.9%
 
ValueCountFrequency (%) 
0.00110.9%
 
0.001110.9%
 
0.001510.9%
 
0.001710.9%
 
0.00210.9%
 
ValueCountFrequency (%) 
0.053410.9%
 
0.045610.9%
 
0.041310.9%
 
0.039410.9%
 
0.032910.9%
 

EPC
Real number (ℝ≥0)

ZEROS

Distinct count47
Unique (%)43.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.27844036697247704
Minimum0.0
Maximum0.66
Zeros5
Zeros (%)4.6%
Memory size872.0 B

Quantile statistics

Minimum0
5-th percentile0.052
Q10.2
median0.26
Q30.36
95-th percentile0.52
Maximum0.66
Range0.66
Interquartile range (IQR)0.16

Descriptive statistics

Standard deviation0.1421017783
Coefficient of variation (CV)0.5103490555
Kurtosis0.1462308067
Mean0.278440367
Median Absolute Deviation (MAD)0.09
Skewness0.3599414382
Sum30.35
Variance0.02019291539
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.2176.4%
 
0.3265.5%
 
0.2365.5%
 
0.4154.6%
 
0.2454.6%
 
054.6%
 
0.243.7%
 
0.1443.7%
 
0.4743.7%
 
0.2843.7%
 
Other values (37)5954.1%
 
ValueCountFrequency (%) 
054.6%
 
0.0410.9%
 
0.0710.9%
 
0.0810.9%
 
0.0910.9%
 
ValueCountFrequency (%) 
0.6610.9%
 
0.6510.9%
 
0.6410.9%
 
0.5710.9%
 
0.5310.9%
 

CLR
Real number (ℝ≥0)

ZEROS

Distinct count54
Unique (%)49.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.006869724770642201
Minimum0.0
Maximum0.0856
Zeros33
Zeros (%)30.3%
Memory size872.0 B

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.0031
Q30.0064
95-th percentile0.0157
Maximum0.0856
Range0.0856
Interquartile range (IQR)0.0064

Descriptive statistics

Standard deviation0.01495860649
Coefficient of variation (CV)2.177468093
Kurtosis17.61872601
Mean0.006869724771
Median Absolute Deviation (MAD)0.0031
Skewness4.191017426
Sum0.7488
Variance0.0002237599083
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
03330.3%
 
0.002543.7%
 
0.001932.8%
 
0.011732.8%
 
0.005332.8%
 
0.005632.8%
 
0.003121.8%
 
0.003321.8%
 
0.006421.8%
 
0.006321.8%
 
Other values (44)5247.7%
 
ValueCountFrequency (%) 
03330.3%
 
0.000610.9%
 
0.001410.9%
 
0.001510.9%
 
0.001621.8%
 
ValueCountFrequency (%) 
0.085610.9%
 
0.081810.9%
 
0.075610.9%
 
0.058910.9%
 
0.056810.9%
 

# Drops
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)0.9%
Missing0
Missing (%)0.0%
Memory size872.0 B
1
109
ValueCountFrequency (%) 
1109100.0%
 

Click Rate
Real number (ℝ≥0)

Distinct count92
Unique (%)84.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.10691467889908259
Minimum0.027
Maximum0.281
Zeros0
Zeros (%)0.0%
Memory size872.0 B

Quantile statistics

Minimum0.027
5-th percentile0.04504
Q10.0801
median0.1012
Q30.1278
95-th percentile0.1908
Maximum0.281
Range0.254
Interquartile range (IQR)0.0477

Descriptive statistics

Standard deviation0.04607362631
Coefficient of variation (CV)0.4309382658
Kurtosis2.01640169
Mean0.1069146789
Median Absolute Deviation (MAD)0.0248
Skewness1.150918925
Sum11.6537
Variance0.002122779042
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.10932.8%
 
0.09532.8%
 
0.08732.8%
 
0.06721.8%
 
0.11121.8%
 
0.07521.8%
 
0.08221.8%
 
0.08421.8%
 
0.12121.8%
 
0.10821.8%
 
Other values (82)8678.9%
 
ValueCountFrequency (%) 
0.02710.9%
 
0.02810.9%
 
0.04310.9%
 
0.04410.9%
 
0.04521.8%
 
ValueCountFrequency (%) 
0.28110.9%
 
0.24710.9%
 
0.23410.9%
 
0.22310.9%
 
0.212110.9%
 

Clicks
Real number (ℝ≥0)

Distinct count105
Unique (%)96.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean597.5045871559633
Minimum42
Maximum3621
Zeros0
Zeros (%)0.0%
Memory size872.0 B

Quantile statistics

Minimum42
5-th percentile116
Q1283
median476
Q3759
95-th percentile1570
Maximum3621
Range3579
Interquartile range (IQR)476

Descriptive statistics

Standard deviation505.6823154
Coefficient of variation (CV)0.8463237376
Kurtosis11.48771409
Mean597.5045872
Median Absolute Deviation (MAD)225
Skewness2.667603589
Sum65128
Variance255714.6041
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
18321.8%
 
52721.8%
 
73021.8%
 
20621.8%
 
101910.9%
 
84710.9%
 
29310.9%
 
56610.9%
 
82710.9%
 
31910.9%
 
Other values (95)9587.2%
 
ValueCountFrequency (%) 
4210.9%
 
7410.9%
 
8310.9%
 
10810.9%
 
10910.9%
 
ValueCountFrequency (%) 
362110.9%
 
197110.9%
 
183610.9%
 
182710.9%
 
172110.9%
 

Date1
Date

Distinct count52
Unique (%)47.7%
Missing0
Missing (%)0.0%
Memory size872.0 B
Minimum2020-01-31 00:00:00
Maximum2020-04-12 00:00:00
Histogram

Delivered
Real number (ℝ≥0)

HIGH CORRELATION
UNIQUE

Distinct count109
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean52829.5871559633
Minimum6812
Maximum688381
Zeros0
Zeros (%)0.0%
Memory size872.0 B

Quantile statistics

Minimum6812
5-th percentile14246.6
Q126151
median38125
Q360720
95-th percentile150529.4
Maximum688381
Range681569
Interquartile range (IQR)34569

Descriptive statistics

Standard deviation69998.11759
Coefficient of variation (CV)1.324979455
Kurtosis63.72661776
Mean52829.58716
Median Absolute Deviation (MAD)16312
Skewness7.20160629
Sum5758425
Variance4899736466
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
68838110.9%
 
4217110.9%
 
784810.9%
 
2028710.9%
 
2951110.9%
 
4717810.9%
 
15545310.9%
 
1415710.9%
 
3463910.9%
 
6843210.9%
 
Other values (99)9990.8%
 
ValueCountFrequency (%) 
681210.9%
 
686410.9%
 
740110.9%
 
784810.9%
 
1397010.9%
 
ValueCountFrequency (%) 
68838110.9%
 
15740810.9%
 
15545310.9%
 
15220610.9%
 
15214710.9%
 

Offer ID1
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)0.9%
Missing0
Missing (%)0.0%
Memory size872.0 B
4915
109
ValueCountFrequency (%) 
4915109100.0%
 

Length

Max length4
Median length4
Mean length4
Min length4

Open Rate
Real number (ℝ≥0)

Distinct count94
Unique (%)86.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.14038073394495412
Minimum0.005
Maximum0.342
Zeros0
Zeros (%)0.0%
Memory size872.0 B

Quantile statistics

Minimum0.005
5-th percentile0.03296
Q10.1019
median0.135
Q30.171
95-th percentile0.27524
Maximum0.342
Range0.337
Interquartile range (IQR)0.0691

Descriptive statistics

Standard deviation0.06770971739
Coefficient of variation (CV)0.4823291308
Kurtosis1.090895719
Mean0.1403807339
Median Absolute Deviation (MAD)0.034
Skewness0.7135547855
Sum15.3015
Variance0.004584605829
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.0932.8%
 
0.13132.8%
 
0.14321.8%
 
0.15321.8%
 
0.16121.8%
 
0.21921.8%
 
0.18521.8%
 
0.16421.8%
 
0.10121.8%
 
0.08521.8%
 
Other values (84)8779.8%
 
ValueCountFrequency (%) 
0.00510.9%
 
0.00721.8%
 
0.01410.9%
 
0.01510.9%
 
0.032610.9%
 
ValueCountFrequency (%) 
0.34210.9%
 
0.32710.9%
 
0.32210.9%
 
0.31310.9%
 
0.28610.9%
 

Opens
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count108
Unique (%)99.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7157.8899082568805
Minimum631
Maximum130167
Zeros0
Zeros (%)0.0%
Memory size872.0 B

Quantile statistics

Minimum631
5-th percentile888.4
Q12645
median4719
Q37604
95-th percentile18330.2
Maximum130167
Range129536
Interquartile range (IQR)4959

Descriptive statistics

Standard deviation12827.57427
Coefficient of variation (CV)1.79208879
Kurtosis79.76369562
Mean7157.889908
Median Absolute Deviation (MAD)2261
Skewness8.360274
Sum780210
Variance164546661.6
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
231021.8%
 
793410.9%
 
580710.9%
 
1917510.9%
 
545510.9%
 
468910.9%
 
213010.9%
 
2158810.9%
 
264510.9%
 
367010.9%
 
Other values (98)9889.9%
 
ValueCountFrequency (%) 
63110.9%
 
71310.9%
 
73110.9%
 
74110.9%
 
83010.9%
 
ValueCountFrequency (%) 
13016710.9%
 
2158810.9%
 
2118610.9%
 
1969310.9%
 
1942910.9%
 

Remaining Budget
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)0.9%
Missing0
Missing (%)0.0%
Memory size872.0 B
0
109
ValueCountFrequency (%) 
0109100.0%
 

Revenue
Real number (ℝ≥0)

ZEROS

Distinct count29
Unique (%)26.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean169.6880733944954
Minimum0
Maximum935
Zeros5
Zeros (%)4.6%
Memory size872.0 B

Quantile statistics

Minimum0
5-th percentile17
Q168
median119
Q3204
95-th percentile506.6
Maximum935
Range935
Interquartile range (IQR)136

Descriptive statistics

Standard deviation171.2543429
Coefficient of variation (CV)1.009230286
Kurtosis6.502105285
Mean169.6880734
Median Absolute Deviation (MAD)68
Skewness2.355060711
Sum18496
Variance29328.04995
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1021311.9%
 
851211.0%
 
3487.3%
 
17076.4%
 
5165.5%
 
18754.6%
 
1754.6%
 
15354.6%
 
6854.6%
 
054.6%
 
Other values (19)3834.9%
 
ValueCountFrequency (%) 
054.6%
 
1754.6%
 
3487.3%
 
5165.5%
 
6854.6%
 
ValueCountFrequency (%) 
93510.9%
 
81610.9%
 
76510.9%
 
74810.9%
 
61210.9%
 

Name_First Access Solid B
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)0.9%
Missing0
Missing (%)0.0%
Memory size109.0 B
1
109
ValueCountFrequency (%) 
1109100.0%
 

Data Provider (group)_Irvine
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
97
1
 
12
ValueCountFrequency (%) 
09789.0%
 
11211.0%
 

Data Provider (group)_Venice
Boolean

HIGH CORRELATION

Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
1
97
0
 
12
ValueCountFrequency (%) 
19789.0%
 
01211.0%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
108
1
 
1
ValueCountFrequency (%) 
010899.1%
 
110.9%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
70
1
39
ValueCountFrequency (%) 
07064.2%
 
13935.8%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
102
1
 
7
ValueCountFrequency (%) 
010293.6%
 
176.4%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
106
1
 
3
ValueCountFrequency (%) 
010697.2%
 
132.8%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
104
1
 
5
ValueCountFrequency (%) 
010495.4%
 
154.6%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
108
1
 
1
ValueCountFrequency (%) 
010899.1%
 
110.9%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
67
1
42
ValueCountFrequency (%) 
06761.5%
 
14238.5%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
107
1
 
2
ValueCountFrequency (%) 
010798.2%
 
121.8%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
100
1
 
9
ValueCountFrequency (%) 
010091.7%
 
198.3%
 
Distinct count1
Unique (%)0.9%
Missing0
Missing (%)0.0%
Memory size109.0 B
1
109
ValueCountFrequency (%) 
1109100.0%
 

Operational Status1_Live
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)0.9%
Missing0
Missing (%)0.0%
Memory size109.0 B
1
109
ValueCountFrequency (%) 
1109100.0%
 

Payout Type1_1st PAGE SUBMIT
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)0.9%
Missing0
Missing (%)0.0%
Memory size109.0 B
1
109
ValueCountFrequency (%) 
1109100.0%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
108
1
 
1
ValueCountFrequency (%) 
010899.1%
 
110.9%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
106
1
 
3
ValueCountFrequency (%) 
010697.2%
 
132.8%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
103
1
 
6
ValueCountFrequency (%) 
010394.5%
 
165.5%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
107
1
 
2
ValueCountFrequency (%) 
010798.2%
 
121.8%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
101
1
 
8
ValueCountFrequency (%) 
010192.7%
 
187.3%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
0
94
1
 
15
ValueCountFrequency (%) 
09486.2%
 
11513.8%
 
Distinct count2
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size109.0 B
1
74
0
35
ValueCountFrequency (%) 
17467.9%
 
03532.1%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

Sample

First rows

Affiliate ID1eCPMCTREPCCLR# DropsClick RateClicksDate1DeliveredOffer ID1Open RateOpensRemaining BudgetRevenueName_First Access Solid BData Provider (group)_IrvineData Provider (group)_VeniceData Vertical_Auto LoanData Vertical_CreditData Vertical_FHAData Vertical_GrantsData Vertical_InternalData Vertical_PaleoData Vertical_Personal LoanData Vertical_RefinanceData Vertical_Rent To OwnOffer Name1_First Access Solid Black Visa Credit Card - Display - Lead Submit - W4 (e-mail)Operational Status1_LivePayout Type1_1st PAGE SUBMITSegment1_A14Segment1_A21Segment1_MISegment1_O1Segment1_O14Segment1_O21Segment1_O30
04606395.480.01930.280.010.10427772020-03-024031849150.185745802211010100000001110000001
14608044.020.01960.210.010.121012402020-04-096341949150.1611023102551010000001001110000100
246063911.410.04130.280.010.12606152020-03-131489949150.327487401701010100000001110001000
34606398.230.04560.180.010.14606592020-03-271445149150.313451801191010100000001110001000
446080412.580.02650.470.010.121019712020-03-227433749150.2191631409351010000001001110000010
546080411.760.02630.450.010.163018272020-03-126940849150.1611118508161010000001001110000010
646046711.250.02400.470.010.084016302020-03-106798849150.2861942907651010000001001110000100
74604671.560.00670.230.010.05703632020-03-205457649150.11763930851010000001001110000100
84604672.240.00670.330.010.06604082020-04-096072049150.101615701361010000001001110000100
94606393.730.01600.230.010.10507302020-04-084562249150.153698001701010100000001110000001

Last rows

Affiliate ID1eCPMCTREPCCLR# DropsClick RateClicksDate1DeliveredOffer ID1Open RateOpensRemaining BudgetRevenueName_First Access Solid BData Provider (group)_IrvineData Provider (group)_VeniceData Vertical_Auto LoanData Vertical_CreditData Vertical_FHAData Vertical_GrantsData Vertical_InternalData Vertical_PaleoData Vertical_Personal LoanData Vertical_RefinanceData Vertical_Rent To OwnOffer Name1_First Access Solid Black Visa Credit Card - Display - Lead Submit - W4 (e-mail)Operational Status1_LivePayout Type1_1st PAGE SUBMITSegment1_A14Segment1_A21Segment1_MISegment1_O1Segment1_O14Segment1_O21Segment1_O30
994607502.680.01120.240.003310.08604972020-04-014434749150.1310580701191010000000011110000001
10046035110.480.03140.330.001610.114613252020-02-114217149150.27411155704421010100000001110000001
1014603515.350.01690.320.000610.08016462020-02-233812549150.2116806902041010100000001110000001
1024604832.060.00890.230.000010.05592942020-02-273307049150.159152620681010010000001110000001
1034606390.400.01070.040.000010.13124582020-02-034295649150.081234900171010100000001110000001
1044607243.820.01080.350.000010.07982892020-02-072672249150.1355362201021010000000011110000001
1054607241.170.01290.090.000010.08143742020-02-292897649150.158645950341010000000011110000001
1064607437.520.01150.660.000010.08303892020-02-233390549150.1383468902551010000001001110000100
1074607434.540.01410.320.000010.08184762020-02-293367249150.1727581601531010000001001110000100
1084607439.460.02320.410.000010.12928752020-02-163773349150.1794677103571010000001001110000001